CREATE TABLE [dbo].[DnnProduct_CDS_Currencies]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[Name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CurrencySymbol] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ISOCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ExchangeRate] [decimal] (12, 4) NULL,
[LastUpdated] [datetime] NULL,
[Provider] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_CDS_Currencies] ADD CONSTRAINT [PK_DnnProduct_CDS_Currencies] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [UIX_DnnProduct_CDS_Currencies_ISOCode] ON [dbo].[DnnProduct_CDS_Currencies] ([ISOCode]) ON [PRIMARY]
GO
